Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 679 |
| Missing cells | 2948 |
| Missing cells (%) | 22.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 100.9 KiB |
| Average record size in memory | 152.2 B |
Variable types
| Numeric | 13 |
|---|---|
| DateTime | 1 |
| Categorical | 5 |
Channel has constant value "Reclame Aqui" | Constant |
Tickets has constant value "1" | Constant |
Requester email has a high cardinality: 679 distinct values | High cardinality |
df_index is highly correlated with Requester external ID and 1 other fields | High correlation |
Requester external ID is highly correlated with df_index and 1 other fields | High correlation |
Requester_ID is highly correlated with df_index and 1 other fields | High correlation |
Volume_CHAT is highly correlated with Volume_SOCIAL and 2 other fields | High correlation |
Volume_SOCIAL is highly correlated with Volume_CHAT and 3 other fields | High correlation |
Tempo_Medio_Chat is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
Tempo_Medio_Social is highly correlated with Volume_CHAT and 2 other fields | High correlation |
AWT_Chat is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
CSAT_Rated is highly correlated with Volume_CHAT and 1 other fields | High correlation |
df_index is highly correlated with Requester external ID and 1 other fields | High correlation |
Requester external ID is highly correlated with df_index and 1 other fields | High correlation |
Requester_ID is highly correlated with df_index and 1 other fields | High correlation |
Volume_CHAT is highly correlated with Volume_SOCIAL and 2 other fields | High correlation |
Volume_SOCIAL is highly correlated with Volume_CHAT and 3 other fields | High correlation |
Tempo_Medio_Chat is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
Tempo_Medio_Social is highly correlated with Volume_CHAT and 3 other fields | High correlation |
AWT_Chat is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
%NFCR is highly correlated with Volume_CHAT and 1 other fields | High correlation |
%Insatisfação(CSAT) is highly correlated with CSAT_Rated | High correlation |
CSAT_Rated is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
df_index is highly correlated with Requester external ID and 1 other fields | High correlation |
Requester external ID is highly correlated with df_index and 1 other fields | High correlation |
Requester_ID is highly correlated with df_index and 1 other fields | High correlation |
Volume_CHAT is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
Volume_SOCIAL is highly correlated with Volume_CHAT and 3 other fields | High correlation |
Tempo_Medio_Chat is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
Tempo_Medio_Social is highly correlated with Volume_CHAT and 3 other fields | High correlation |
AWT_Chat is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
%NFCR is highly correlated with Tempo_Medio_Social | High correlation |
%Insatisfação(CSAT) is highly correlated with CSAT_Rated | High correlation |
CSAT_Rated is highly correlated with Volume_SOCIAL and 1 other fields | High correlation |
Volume_SOCIAL is highly correlated with Requester_ID and 4 other fields | High correlation |
Requester_ID is highly correlated with Volume_SOCIAL and 3 other fields | High correlation |
%Insatisfação(CSAT) is highly correlated with CSAT_Rated and 1 other fields | High correlation |
Ticket ID is highly correlated with Volume_SOCIAL and 2 other fields | High correlation |
%NFCR is highly correlated with Volume_EMAIL and 2 other fields | High correlation |
Tempo_Medio_Social is highly correlated with Requester_ID and 4 other fields | High correlation |
Volume_EMAIL is highly correlated with %NFCR | High correlation |
Requester external ID is highly correlated with Volume_SOCIAL and 3 other fields | High correlation |
CSAT_Rated is highly correlated with %Insatisfação(CSAT) and 1 other fields | High correlation |
Volume_CHAT is highly correlated with %Insatisfação(CSAT) and 2 other fields | High correlation |
Assignee email is highly correlated with Volume_SOCIAL and 4 other fields | High correlation |
Tempo_Medio_Email is highly correlated with Assignee email | High correlation |
df_index is highly correlated with Volume_SOCIAL and 3 other fields | High correlation |
Volume_SOCIAL is highly correlated with Channel and 2 other fields | High correlation |
Channel is highly correlated with Volume_SOCIAL and 2 other fields | High correlation |
Tickets is highly correlated with Volume_SOCIAL and 2 other fields | High correlation |
Assignee email is highly correlated with Volume_SOCIAL and 2 other fields | High correlation |
Volume_CHAT has 261 (38.4%) missing values | Missing |
Volume_EMAIL has 408 (60.1%) missing values | Missing |
Volume_SOCIAL has 672 (99.0%) missing values | Missing |
Tempo_Medio_Chat has 264 (38.9%) missing values | Missing |
Tempo_Medio_Email has 409 (60.2%) missing values | Missing |
Tempo_Medio_Social has 672 (99.0%) missing values | Missing |
AWT_Chat has 262 (38.6%) missing values | Missing |
Requester email is uniformly distributed | Uniform |
df_index has unique values | Unique |
Requester external ID has unique values | Unique |
Ticket ID has unique values | Unique |
Requester email has unique values | Unique |
Requester_ID has unique values | Unique |
%NFCR has 427 (62.9%) zeros | Zeros |
%Insatisfação(CSAT) has 562 (82.8%) zeros | Zeros |
CSAT_Rated has 429 (63.2%) zeros | Zeros |
Reproduction
| Analysis started | 2021-06-15 16:41:28.822579 |
|---|---|
| Analysis finished | 2021-06-15 16:42:01.187303 |
| Duration | 32.36 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
df_index
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 679 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 463.3460972 |
| Minimum | 0 |
|---|---|
| Maximum | 932 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 43.9 |
| Q1 | 239.5 |
| median | 455 |
| Q3 | 692.5 |
| 95-th percentile | 886.1 |
| Maximum | 932 |
| Range | 932 |
| Interquartile range (IQR) | 453 |
Descriptive statistics
| Standard deviation | 266.857943 |
|---|---|
| Coefficient of variation (CV) | 0.5759365291 |
| Kurtosis | -1.156358872 |
| Mean | 463.3460972 |
| Median Absolute Deviation (MAD) | 230 |
| Skewness | 0.03692166865 |
| Sum | 314612 |
| Variance | 71213.16175 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 932 | 1 | 0.1% |
| 308 | 1 | 0.1% |
| 321 | 1 | 0.1% |
| 319 | 1 | 0.1% |
| 318 | 1 | 0.1% |
| 317 | 1 | 0.1% |
| 316 | 1 | 0.1% |
| 314 | 1 | 0.1% |
| 311 | 1 | 0.1% |
| 310 | 1 | 0.1% |
| Other values (669) | 669 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 7 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 12 | 1 |
| Value | Count | Frequency (%) |
| 932 | 1 | |
| 930 | 1 | |
| 929 | 1 | |
| 928 | 1 | |
| 927 | 1 | |
| 926 | 1 | |
| 924 | 1 | |
| 923 | 1 | |
| 922 | 1 | |
| 920 | 1 |
Requester external ID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 679 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8347895.549 |
| Minimum | 21593 |
|---|---|
| Maximum | 19066870 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 21593 |
|---|---|
| 5-th percentile | 453050.4 |
| Q1 | 3568784 |
| median | 7780143 |
| Q3 | 13384518.5 |
| 95-th percentile | 17118987.9 |
| Maximum | 19066870 |
| Range | 19045277 |
| Interquartile range (IQR) | 9815734.5 |
Descriptive statistics
| Standard deviation | 5521532.082 |
|---|---|
| Coefficient of variation (CV) | 0.6614280269 |
| Kurtosis | -1.183382488 |
| Mean | 8347895.549 |
| Median Absolute Deviation (MAD) | 4579825 |
| Skewness | 0.1897955962 |
| Sum | 5668221078 |
| Variance | 3.048731653 × 1013 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 8863733 | 1 | 0.1% |
| 5089973 | 1 | 0.1% |
| 7940867 | 1 | 0.1% |
| 8140532 | 1 | 0.1% |
| 18525146 | 1 | 0.1% |
| 10540509 | 1 | 0.1% |
| 931164 | 1 | 0.1% |
| 17050426 | 1 | 0.1% |
| 6179523 | 1 | 0.1% |
| 14226811 | 1 | 0.1% |
| Other values (669) | 669 |
| Value | Count | Frequency (%) |
| 21593 | 1 | |
| 30084 | 1 | |
| 47027 | 1 | |
| 54194 | 1 | |
| 56234 | 1 | |
| 57350 | 1 | |
| 58058 | 1 | |
| 58246 | 1 | |
| 67449 | 1 | |
| 81043 | 1 |
| Value | Count | Frequency (%) |
| 19066870 | 1 | |
| 18934000 | 1 | |
| 18868795 | 1 | |
| 18845344 | 1 | |
| 18838144 | 1 | |
| 18814467 | 1 | |
| 18685771 | 1 | |
| 18685162 | 1 | |
| 18655961 | 1 | |
| 18640265 | 1 |
| Distinct | 113 |
|---|---|
| Distinct (%) | 16.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| Minimum | 2021-01-04 00:00:00 |
|---|---|
| Maximum | 2021-06-10 00:00:00 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| Reclame Aqui |
|---|
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 8148 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reclame Aqui |
|---|---|
| 2nd row | Reclame Aqui |
| 3rd row | Reclame Aqui |
| 4th row | Reclame Aqui |
| 5th row | Reclame Aqui |
Common Values
| Value | Count | Frequency (%) |
| Reclame Aqui | 679 |
Length
Pie chart
| Value | Count | Frequency (%) |
| aqui | 679 | |
| reclame | 679 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1358 | |
| R | 679 | |
| c | 679 | |
| l | 679 | |
| a | 679 | |
| m | 679 | |
| 679 | ||
| A | 679 | |
| q | 679 | |
| u | 679 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6111 | |
| Uppercase Letter | 1358 | 16.7% |
| Space Separator | 679 | 8.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1358 | |
| c | 679 | |
| l | 679 | |
| a | 679 | |
| m | 679 | |
| q | 679 | |
| u | 679 | |
| i | 679 |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 679 | |
| A | 679 |
Space Separator
| Value | Count | Frequency (%) |
| 679 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7469 | |
| Common | 679 | 8.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1358 | |
| R | 679 | |
| c | 679 | |
| l | 679 | |
| a | 679 | |
| m | 679 | |
| A | 679 | |
| q | 679 | |
| u | 679 | |
| i | 679 |
Common
| Value | Count | Frequency (%) |
| 679 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8148 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1358 | |
| R | 679 | |
| c | 679 | |
| l | 679 | |
| a | 679 | |
| m | 679 | |
| 679 | ||
| A | 679 | |
| q | 679 | |
| u | 679 |
| Distinct | 679 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3765880.471 |
| Minimum | 3459738 |
|---|---|
| Maximum | 4080394 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 3459738 |
|---|---|
| 5-th percentile | 3521072.3 |
| Q1 | 3615320.5 |
| median | 3757266 |
| Q3 | 3922106.5 |
| 95-th percentile | 4017061.3 |
| Maximum | 4080394 |
| Range | 620656 |
| Interquartile range (IQR) | 306786 |
Descriptive statistics
| Standard deviation | 169678.3309 |
|---|---|
| Coefficient of variation (CV) | 0.04505674893 |
| Kurtosis | -1.351913809 |
| Mean | 3765880.471 |
| Median Absolute Deviation (MAD) | 153313 |
| Skewness | 0.03236582552 |
| Sum | 2557032840 |
| Variance | 2.879073597 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3706936 | 1 | 0.1% |
| 3946843 | 1 | 0.1% |
| 3817831 | 1 | 0.1% |
| 3516774 | 1 | 0.1% |
| 3866155 | 1 | 0.1% |
| 3634532 | 1 | 0.1% |
| 3496291 | 1 | 0.1% |
| 3830113 | 1 | 0.1% |
| 3855700 | 1 | 0.1% |
| 3951549 | 1 | 0.1% |
| Other values (669) | 669 |
| Value | Count | Frequency (%) |
| 3459738 | 1 | |
| 3462433 | 1 | |
| 3473530 | 1 | |
| 3473850 | 1 | |
| 3474427 | 1 | |
| 3474659 | 1 | |
| 3485298 | 1 | |
| 3489464 | 1 | |
| 3489502 | 1 | |
| 3492398 | 1 |
| Value | Count | Frequency (%) |
| 4080394 | 1 | |
| 4078417 | 1 | |
| 4078047 | 1 | |
| 4071584 | 1 | |
| 4071351 | 1 | |
| 4069621 | 1 | |
| 4062549 | 1 | |
| 4062341 | 1 | |
| 4058409 | 1 | |
| 4058303 | 1 |
| Distinct | 25 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| kaique.barbosa@gympass.com | |
|---|---|
| suellen.franco+core@gympass.com | |
| danielle.hernandes@gympass.com | |
| luciana.melo@gympass.com | |
| barbara.priscila@gympass.com | |
| Other values (20) |
Length
| Max length | 31 |
|---|---|
| Median length | 27 |
| Mean length | 27.70397644 |
| Min length | 23 |
Characters and Unicode
| Total characters | 18811 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | kaique.barbosa@gympass.com |
|---|---|
| 2nd row | luciana.melo@gympass.com |
| 3rd row | anderson.santos@gympass.com |
| 4th row | gabriel.almeida@gympass.com |
| 5th row | luciana.melo@gympass.com |
Common Values
| Value | Count | Frequency (%) |
| kaique.barbosa@gympass.com | 160 | |
| suellen.franco+core@gympass.com | 121 | |
| danielle.hernandes@gympass.com | 117 | |
| luciana.melo@gympass.com | 79 | |
| barbara.priscila@gympass.com | 67 | |
| anderson.santos@gympass.com | 60 | 8.8% |
| gabriel.almeida@gympass.com | 30 | 4.4% |
| elizabete.damiao@gympass.com | 14 | 2.1% |
| caroline.roberto@gympass.com | 5 | 0.7% |
| aline.colombo@gympass.com | 5 | 0.7% |
| Other values (15) | 21 | 3.1% |
Length
| Value | Count | Frequency (%) |
| kaique.barbosa@gympass.com | 160 | |
| suellen.franco+core@gympass.com | 121 | |
| danielle.hernandes@gympass.com | 117 | |
| luciana.melo@gympass.com | 79 | |
| barbara.priscila@gympass.com | 67 | |
| anderson.santos@gympass.com | 60 | 8.8% |
| gabriel.almeida@gympass.com | 30 | 4.4% |
| elizabete.damiao@gympass.com | 14 | 2.1% |
| caroline.roberto@gympass.com | 5 | 0.7% |
| aline.colombo@gympass.com | 5 | 0.7% |
| Other values (15) | 21 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2245 | |
| s | 2024 | 10.8% |
| m | 1493 | 7.9% |
| . | 1357 | 7.2% |
| o | 1347 | 7.2% |
| e | 1271 | 6.8% |
| c | 1088 | 5.8% |
| n | 883 | 4.7% |
| r | 847 | 4.5% |
| l | 802 | 4.3% |
| Other values (19) | 5454 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 16651 | |
| Other Punctuation | 2036 | 10.8% |
| Math Symbol | 121 | 0.6% |
| Connector Punctuation | 2 | < 0.1% |
| Decimal Number | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2245 | |
| s | 2024 | |
| m | 1493 | 9.0% |
| o | 1347 | 8.1% |
| e | 1271 | 7.6% |
| c | 1088 | 6.5% |
| n | 883 | 5.3% |
| r | 847 | 5.1% |
| l | 802 | 4.8% |
| p | 747 | 4.5% |
| Other values (14) | 3904 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1357 | |
| @ | 679 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 121 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16651 | |
| Common | 2160 | 11.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 2245 | |
| s | 2024 | |
| m | 1493 | 9.0% |
| o | 1347 | 8.1% |
| e | 1271 | 7.6% |
| c | 1088 | 6.5% |
| n | 883 | 5.3% |
| r | 847 | 5.1% |
| l | 802 | 4.8% |
| p | 747 | 4.5% |
| Other values (14) | 3904 |
Common
| Value | Count | Frequency (%) |
| . | 1357 | |
| @ | 679 | |
| + | 121 | 5.6% |
| _ | 2 | 0.1% |
| 1 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18811 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 2245 | |
| s | 2024 | 10.8% |
| m | 1493 | 7.9% |
| . | 1357 | 7.2% |
| o | 1347 | 7.2% |
| e | 1271 | 6.8% |
| c | 1088 | 5.8% |
| n | 883 | 4.7% |
| r | 847 | 4.5% |
| l | 802 | 4.3% |
| Other values (19) | 5454 |
| Distinct | 679 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| rafaela.almeida@facc.ufjf.br | 1 |
|---|---|
| gustavo.hocarvalho@hsl.org.br | 1 |
| rpereira.png@gmail.com | 1 |
| ka.erika2@gmail.com | 1 |
| nolive22@ford.com | 1 |
| Other values (674) |
Length
| Max length | 67 |
|---|---|
| Median length | 25 |
| Mean length | 25.04565538 |
| Min length | 12 |
Characters and Unicode
| Total characters | 17006 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 679 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | joabinho99@hotmail.com |
|---|---|
| 2nd row | camila.almeida@unilever.com |
| 3rd row | flashlav@gmail.com |
| 4th row | nancy.jikihara@voith.com |
| 5th row | erikabazilio19@gmail.com |
Common Values
| Value | Count | Frequency (%) |
| rafaela.almeida@facc.ufjf.br | 1 | 0.1% |
| gustavo.hocarvalho@hsl.org.br | 1 | 0.1% |
| rpereira.png@gmail.com | 1 | 0.1% |
| ka.erika2@gmail.com | 1 | 0.1% |
| nolive22@ford.com | 1 | 0.1% |
| nilsonmaesta@gmail.com | 1 | 0.1% |
| mirna.folco@fundacaorenova.org | 1 | 0.1% |
| alves3392@hotmail.com | 1 | 0.1% |
| guilhermemoura403@gmail.com | 1 | 0.1% |
| talita.esperandio@localiza.com | 1 | 0.1% |
| Other values (669) | 669 |
Length
| Value | Count | Frequency (%) |
| rafaela.almeida@facc.ufjf.br | 1 | 0.1% |
| gustavo.hocarvalho@hsl.org.br | 1 | 0.1% |
| rpereira.png@gmail.com | 1 | 0.1% |
| ka.erika2@gmail.com | 1 | 0.1% |
| nolive22@ford.com | 1 | 0.1% |
| nilsonmaesta@gmail.com | 1 | 0.1% |
| mirna.folco@fundacaorenova.org | 1 | 0.1% |
| alves3392@hotmail.com | 1 | 0.1% |
| guilhermemoura403@gmail.com | 1 | 0.1% |
| talita.esperandio@localiza.com | 1 | 0.1% |
| Other values (669) | 669 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1904 | 11.2% |
| o | 1668 | 9.8% |
| m | 1363 | 8.0% |
| i | 1257 | 7.4% |
| . | 1126 | 6.6% |
| l | 1061 | 6.2% |
| c | 1028 | 6.0% |
| r | 913 | 5.4% |
| e | 868 | 5.1% |
| @ | 679 | 4.0% |
| Other values (30) | 5139 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14636 | |
| Other Punctuation | 1805 | 10.6% |
| Decimal Number | 457 | 2.7% |
| Connector Punctuation | 62 | 0.4% |
| Dash Punctuation | 46 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1904 | |
| o | 1668 | |
| m | 1363 | |
| i | 1257 | 8.6% |
| l | 1061 | 7.2% |
| c | 1028 | 7.0% |
| r | 913 | 6.2% |
| e | 868 | 5.9% |
| s | 639 | 4.4% |
| n | 610 | 4.2% |
| Other values (16) | 3325 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 79 | |
| 0 | 67 | |
| 2 | 61 | |
| 9 | 48 | |
| 8 | 41 | |
| 3 | 38 | |
| 4 | 34 | |
| 5 | 33 | |
| 6 | 29 | 6.3% |
| 7 | 27 | 5.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1126 | |
| @ | 679 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 62 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 46 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14636 | |
| Common | 2370 | 13.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1904 | |
| o | 1668 | |
| m | 1363 | |
| i | 1257 | 8.6% |
| l | 1061 | 7.2% |
| c | 1028 | 7.0% |
| r | 913 | 6.2% |
| e | 868 | 5.9% |
| s | 639 | 4.4% |
| n | 610 | 4.2% |
| Other values (16) | 3325 |
Common
| Value | Count | Frequency (%) |
| . | 1126 | |
| @ | 679 | |
| 1 | 79 | 3.3% |
| 0 | 67 | 2.8% |
| _ | 62 | 2.6% |
| 2 | 61 | 2.6% |
| 9 | 48 | 2.0% |
| - | 46 | 1.9% |
| 8 | 41 | 1.7% |
| 3 | 38 | 1.6% |
| Other values (4) | 123 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17006 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1904 | 11.2% |
| o | 1668 | 9.8% |
| m | 1363 | 8.0% |
| i | 1257 | 7.4% |
| . | 1126 | 6.6% |
| l | 1061 | 6.2% |
| c | 1028 | 6.0% |
| r | 913 | 5.4% |
| e | 868 | 5.1% |
| @ | 679 | 4.0% |
| Other values (30) | 5139 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 679 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 679 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 679 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 679 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 679 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 679 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 679 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 679 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 679 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 679 |
Requester_ID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 679 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8347895.549 |
| Minimum | 21593 |
|---|---|
| Maximum | 19066870 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 21593 |
|---|---|
| 5-th percentile | 453050.4 |
| Q1 | 3568784 |
| median | 7780143 |
| Q3 | 13384518.5 |
| 95-th percentile | 17118987.9 |
| Maximum | 19066870 |
| Range | 19045277 |
| Interquartile range (IQR) | 9815734.5 |
Descriptive statistics
| Standard deviation | 5521532.082 |
|---|---|
| Coefficient of variation (CV) | 0.6614280269 |
| Kurtosis | -1.183382488 |
| Mean | 8347895.549 |
| Median Absolute Deviation (MAD) | 4579825 |
| Skewness | 0.1897955962 |
| Sum | 5668221078 |
| Variance | 3.048731653 × 1013 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 8366164 | 1 | 0.1% |
| 5291346 | 1 | 0.1% |
| 10114398 | 1 | 0.1% |
| 13774018 | 1 | 0.1% |
| 931164 | 1 | 0.1% |
| 1216550 | 1 | 0.1% |
| 7842137 | 1 | 0.1% |
| 3350869 | 1 | 0.1% |
| 12527146 | 1 | 0.1% |
| 9139539 | 1 | 0.1% |
| Other values (669) | 669 |
| Value | Count | Frequency (%) |
| 21593 | 1 | |
| 30084 | 1 | |
| 47027 | 1 | |
| 54194 | 1 | |
| 56234 | 1 | |
| 57350 | 1 | |
| 58058 | 1 | |
| 58246 | 1 | |
| 67449 | 1 | |
| 81043 | 1 |
| Value | Count | Frequency (%) |
| 19066870 | 1 | |
| 18934000 | 1 | |
| 18868795 | 1 | |
| 18845344 | 1 | |
| 18838144 | 1 | |
| 18814467 | 1 | |
| 18685771 | 1 | |
| 18685162 | 1 | |
| 18655961 | 1 | |
| 18640265 | 1 |
Volume_CHAT
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 12 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 261 |
| Missing (%) | 38.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.294258373 |
| Minimum | 0 |
|---|---|
| Maximum | 16 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.919736081 |
|---|---|
| Coefficient of variation (CV) | 0.8367567066 |
| Kurtosis | 11.45467045 |
| Mean | 2.294258373 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.668019466 |
| Sum | 959 |
| Variance | 3.685386619 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 203 | |
| 2 | 76 | 11.2% |
| 3 | 62 | 9.1% |
| 4 | 32 | 4.7% |
| 5 | 21 | 3.1% |
| 7 | 6 | 0.9% |
| 6 | 6 | 0.9% |
| 8 | 5 | 0.7% |
| 9 | 4 | 0.6% |
| 15 | 1 | 0.1% |
| Other values (2) | 2 | 0.3% |
| (Missing) | 261 |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 1 | 203 | |
| 2 | 76 | 11.2% |
| 3 | 62 | 9.1% |
| 4 | 32 | 4.7% |
| 5 | 21 | 3.1% |
| 6 | 6 | 0.9% |
| 7 | 6 | 0.9% |
| 8 | 5 | 0.7% |
| 9 | 4 | 0.6% |
| Value | Count | Frequency (%) |
| 16 | 1 | 0.1% |
| 15 | 1 | 0.1% |
| 9 | 4 | 0.6% |
| 8 | 5 | 0.7% |
| 7 | 6 | 0.9% |
| 6 | 6 | 0.9% |
| 5 | 21 | 3.1% |
| 4 | 32 | |
| 3 | 62 | |
| 2 | 76 |
| Distinct | 8 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 408 |
| Missing (%) | 60.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.586715867 |
| Minimum | 1 |
|---|---|
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3.5 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.185892658 |
|---|---|
| Coefficient of variation (CV) | 0.7473881636 |
| Kurtosis | 21.35105228 |
| Mean | 1.586715867 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.879229103 |
| Sum | 430 |
| Variance | 1.406341397 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 179 | |
| 2 | 59 | 8.7% |
| 3 | 19 | 2.8% |
| 4 | 8 | 1.2% |
| 5 | 2 | 0.3% |
| 8 | 2 | 0.3% |
| 7 | 1 | 0.1% |
| 11 | 1 | 0.1% |
| (Missing) | 408 |
| Value | Count | Frequency (%) |
| 1 | 179 | |
| 2 | 59 | 8.7% |
| 3 | 19 | 2.8% |
| 4 | 8 | 1.2% |
| 5 | 2 | 0.3% |
| 7 | 1 | 0.1% |
| 8 | 2 | 0.3% |
| 11 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 11 | 1 | 0.1% |
| 8 | 2 | 0.3% |
| 7 | 1 | 0.1% |
| 5 | 2 | 0.3% |
| 4 | 8 | 1.2% |
| 3 | 19 | 2.8% |
| 2 | 59 | 8.7% |
| 1 | 179 |
Volume_SOCIAL
Categorical
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 3 |
|---|---|
| Distinct (%) | 42.9% |
| Missing | 672 |
| Missing (%) | 99.0% |
| Memory size | 5.4 KiB |
| 1.0 | |
|---|---|
| 3.0 | |
| 2.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 21 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 14.3% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 3.0 |
| 3rd row | 3.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 4 | 0.6% |
| 3.0 | 2 | 0.3% |
| 2.0 | 1 | 0.1% |
| (Missing) | 672 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1.0 | 4 | |
| 3.0 | 2 | |
| 2.0 | 1 | 14.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 7 | |
| 0 | 7 | |
| 1 | 4 | |
| 3 | 2 | 9.5% |
| 2 | 1 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 14 | |
| Other Punctuation | 7 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 1 | 4 | |
| 3 | 2 | 14.3% |
| 2 | 1 | 7.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 21 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 7 | |
| 0 | 7 | |
| 1 | 4 | |
| 3 | 2 | 9.5% |
| 2 | 1 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 7 | |
| 0 | 7 | |
| 1 | 4 | |
| 3 | 2 | 9.5% |
| 2 | 1 | 4.8% |
| Distinct | 376 |
|---|---|
| Distinct (%) | 90.6% |
| Missing | 264 |
| Missing (%) | 38.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1496.860241 |
| Minimum | 15 |
|---|---|
| Maximum | 6115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 451.9 |
| Q1 | 923 |
| median | 1324 |
| Q3 | 1874 |
| 95-th percentile | 3055.8 |
| Maximum | 6115 |
| Range | 6100 |
| Interquartile range (IQR) | 951 |
Descriptive statistics
| Standard deviation | 848.0170446 |
|---|---|
| Coefficient of variation (CV) | 0.5665305427 |
| Kurtosis | 3.679638398 |
| Mean | 1496.860241 |
| Median Absolute Deviation (MAD) | 446 |
| Skewness | 1.51206775 |
| Sum | 621197 |
| Variance | 719132.908 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1100 | 3 | 0.4% |
| 1592 | 3 | 0.4% |
| 415 | 3 | 0.4% |
| 857 | 2 | 0.3% |
| 1455 | 2 | 0.3% |
| 1723 | 2 | 0.3% |
| 2769 | 2 | 0.3% |
| 1959 | 2 | 0.3% |
| 1407 | 2 | 0.3% |
| 1409 | 2 | 0.3% |
| Other values (366) | 392 | |
| (Missing) | 264 |
| Value | Count | Frequency (%) |
| 15 | 1 | |
| 57 | 1 | |
| 78 | 1 | |
| 244 | 1 | |
| 263 | 1 | |
| 278 | 1 | |
| 322 | 1 | |
| 354 | 1 | |
| 377 | 1 | |
| 382 | 1 |
| Value | Count | Frequency (%) |
| 6115 | 1 | |
| 5271 | 1 | |
| 4815 | 1 | |
| 4390 | 1 | |
| 4249 | 1 | |
| 4108 | 1 | |
| 4013 | 1 | |
| 3970 | 1 | |
| 3958 | 1 | |
| 3841 | 1 |
| Distinct | 266 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 409 |
| Missing (%) | 60.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12222.52222 |
| Minimum | 1470 |
|---|---|
| Maximum | 134314 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 1470 |
|---|---|
| 5-th percentile | 3069.1 |
| Q1 | 5652.75 |
| median | 8976.5 |
| Q3 | 15106 |
| 95-th percentile | 29221.9 |
| Maximum | 134314 |
| Range | 132844 |
| Interquartile range (IQR) | 9453.25 |
Descriptive statistics
| Standard deviation | 12276.98074 |
|---|---|
| Coefficient of variation (CV) | 1.004455587 |
| Kurtosis | 40.68030281 |
| Mean | 12222.52222 |
| Median Absolute Deviation (MAD) | 4363.5 |
| Skewness | 5.088451653 |
| Sum | 3300081 |
| Variance | 150724256.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7892 | 2 | 0.3% |
| 6891 | 2 | 0.3% |
| 4262 | 2 | 0.3% |
| 15843 | 2 | 0.3% |
| 3296 | 1 | 0.1% |
| 5458 | 1 | 0.1% |
| 22396 | 1 | 0.1% |
| 21026 | 1 | 0.1% |
| 10458 | 1 | 0.1% |
| 18102 | 1 | 0.1% |
| Other values (256) | 256 | |
| (Missing) | 409 |
| Value | Count | Frequency (%) |
| 1470 | 1 | |
| 1634 | 1 | |
| 1932 | 1 | |
| 2111 | 1 | |
| 2172 | 1 | |
| 2183 | 1 | |
| 2244 | 1 | |
| 2525 | 1 | |
| 2569 | 1 | |
| 2640 | 1 |
| Value | Count | Frequency (%) |
| 134314 | 1 | |
| 80964 | 1 | |
| 65903 | 1 | |
| 57865 | 1 | |
| 43397 | 1 | |
| 38705 | 1 | |
| 38520 | 1 | |
| 34728 | 1 | |
| 32963 | 1 | |
| 32724 | 1 |
Tempo_Medio_Social
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 7 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 672 |
| Missing (%) | 99.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15062.14286 |
| Minimum | 5197 |
|---|---|
| Maximum | 40679 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 5197 |
|---|---|
| 5-th percentile | 5217.1 |
| Q1 | 5633 |
| median | 7483 |
| Q3 | 20405 |
| 95-th percentile | 35264.6 |
| Maximum | 40679 |
| Range | 35482 |
| Interquartile range (IQR) | 14772 |
Descriptive statistics
| Standard deviation | 13267.00173 |
|---|---|
| Coefficient of variation (CV) | 0.8808176799 |
| Kurtosis | 1.570188707 |
| Mean | 15062.14286 |
| Median Absolute Deviation (MAD) | 2286 |
| Skewness | 1.418327471 |
| Sum | 105435 |
| Variance | 176013334.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5197 | 1 | 0.1% |
| 40679 | 1 | 0.1% |
| 7483 | 1 | 0.1% |
| 5264 | 1 | 0.1% |
| 6002 | 1 | 0.1% |
| 22631 | 1 | 0.1% |
| 18179 | 1 | 0.1% |
| (Missing) | 672 |
| Value | Count | Frequency (%) |
| 5197 | 1 | |
| 5264 | 1 | |
| 6002 | 1 | |
| 7483 | 1 | |
| 18179 | 1 | |
| 22631 | 1 | |
| 40679 | 1 |
| Value | Count | Frequency (%) |
| 40679 | 1 | |
| 22631 | 1 | |
| 18179 | 1 | |
| 7483 | 1 | |
| 6002 | 1 | |
| 5264 | 1 | |
| 5197 | 1 |
| Distinct | 178 |
|---|---|
| Distinct (%) | 42.7% |
| Missing | 262 |
| Missing (%) | 38.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 144.8009592 |
| Minimum | 5 |
|---|---|
| Maximum | 1981 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 17 |
| median | 35 |
| Q3 | 109 |
| 95-th percentile | 772.2 |
| Maximum | 1981 |
| Range | 1976 |
| Interquartile range (IQR) | 92 |
Descriptive statistics
| Standard deviation | 286.7212634 |
|---|---|
| Coefficient of variation (CV) | 1.980106105 |
| Kurtosis | 15.08869612 |
| Mean | 144.8009592 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 3.604342587 |
| Sum | 60382 |
| Variance | 82209.08288 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 14 | 2.1% |
| 17 | 13 | 1.9% |
| 11 | 12 | 1.8% |
| 19 | 11 | 1.6% |
| 13 | 10 | 1.5% |
| 9 | 10 | 1.5% |
| 12 | 9 | 1.3% |
| 24 | 9 | 1.3% |
| 7 | 9 | 1.3% |
| 14 | 8 | 1.2% |
| Other values (168) | 312 | |
| (Missing) | 262 |
| Value | Count | Frequency (%) |
| 5 | 2 | 0.3% |
| 6 | 7 | |
| 7 | 9 | |
| 8 | 14 | |
| 9 | 10 | |
| 10 | 7 | |
| 11 | 12 | |
| 12 | 9 | |
| 13 | 10 | |
| 14 | 8 |
| Value | Count | Frequency (%) |
| 1981 | 1 | |
| 1810 | 2 | |
| 1750 | 1 | |
| 1691 | 1 | |
| 1479 | 1 | |
| 1208 | 1 | |
| 1191 | 1 | |
| 1011 | 1 | |
| 997 | 1 | |
| 968 | 1 |
| Distinct | 24 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1935250076 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 427 |
| Zeros (%) | 62.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.4 |
| 95-th percentile | 0.75 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.2878945825 |
|---|---|
| Coefficient of variation (CV) | 1.48763504 |
| Kurtosis | 0.6655898517 |
| Mean | 0.1935250076 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.301673725 |
| Sum | 131.4034802 |
| Variance | 0.08288329061 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 427 | |
| 0.5 | 82 | 12.1% |
| 0.3333333333 | 40 | 5.9% |
| 1 | 30 | 4.4% |
| 0.6666666667 | 19 | 2.8% |
| 0.25 | 17 | 2.5% |
| 0.2 | 14 | 2.1% |
| 0.75 | 12 | 1.8% |
| 0.4 | 10 | 1.5% |
| 0.6 | 4 | 0.6% |
| Other values (14) | 24 | 3.5% |
| Value | Count | Frequency (%) |
| 0 | 427 | |
| 0.1666666667 | 3 | 0.4% |
| 0.2 | 14 | 2.1% |
| 0.25 | 17 | 2.5% |
| 0.3 | 2 | 0.3% |
| 0.3333333333 | 40 | 5.9% |
| 0.375 | 2 | 0.3% |
| 0.4 | 10 | 1.5% |
| 0.4285714286 | 3 | 0.4% |
| 0.4444444444 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 30 | |
| 0.8 | 2 | 0.3% |
| 0.7777777778 | 1 | 0.1% |
| 0.75 | 12 | 1.8% |
| 0.7142857143 | 1 | 0.1% |
| 0.7 | 1 | 0.1% |
| 0.6666666667 | 19 | |
| 0.6470588235 | 1 | 0.1% |
| 0.6363636364 | 1 | 0.1% |
| 0.6 | 4 | 0.6% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1507250481 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 562 |
| Zeros (%) | 82.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3438570259 |
|---|---|
| Coefficient of variation (CV) | 2.281352901 |
| Kurtosis | 1.994993866 |
| Mean | 0.1507250481 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.956843913 |
| Sum | 102.3423077 |
| Variance | 0.1182376542 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 562 | |
| 1 | 89 | 13.1% |
| 0.5 | 20 | 2.9% |
| 0.3333333333 | 4 | 0.6% |
| 0.6923076923 | 1 | 0.1% |
| 0.4 | 1 | 0.1% |
| 0.6666666667 | 1 | 0.1% |
| 0.25 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 562 | |
| 0.25 | 1 | 0.1% |
| 0.3333333333 | 4 | 0.6% |
| 0.4 | 1 | 0.1% |
| 0.5 | 20 | 2.9% |
| 0.6666666667 | 1 | 0.1% |
| 0.6923076923 | 1 | 0.1% |
| 1 | 89 | 13.1% |
| Value | Count | Frequency (%) |
| 1 | 89 | 13.1% |
| 0.6923076923 | 1 | 0.1% |
| 0.6666666667 | 1 | 0.1% |
| 0.5 | 20 | 2.9% |
| 0.4 | 1 | 0.1% |
| 0.3333333333 | 4 | 0.6% |
| 0.25 | 1 | 0.1% |
| 0 | 562 |
CSAT_Rated
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 8 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5375552283 |
| Minimum | 0 |
|---|---|
| Maximum | 13 |
| Zeros | 429 |
| Zeros (%) | 63.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9676114356 |
|---|---|
| Coefficient of variation (CV) | 1.800022369 |
| Kurtosis | 44.21342647 |
| Mean | 0.5375552283 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.659882536 |
| Sum | 365 |
| Variance | 0.9362718904 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 429 | |
| 1 | 175 | |
| 2 | 60 | 8.8% |
| 3 | 6 | 0.9% |
| 5 | 5 | 0.7% |
| 4 | 2 | 0.3% |
| 13 | 1 | 0.1% |
| 6 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 429 | |
| 1 | 175 | |
| 2 | 60 | 8.8% |
| 3 | 6 | 0.9% |
| 4 | 2 | 0.3% |
| 5 | 5 | 0.7% |
| 6 | 1 | 0.1% |
| 13 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 13 | 1 | 0.1% |
| 6 | 1 | 0.1% |
| 5 | 5 | 0.7% |
| 4 | 2 | 0.3% |
| 3 | 6 | 0.9% |
| 2 | 60 | 8.8% |
| 1 | 175 | |
| 0 | 429 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | Requester external ID | Ticket created - Date | Channel | Ticket ID | Assignee email | Requester email | Tickets | Requester_ID | Volume_CHAT | Volume_EMAIL | Volume_SOCIAL | Tempo_Medio_Chat | Tempo_Medio_Email | Tempo_Medio_Social | AWT_Chat | %NFCR | %Insatisfação(CSAT) | CSAT_Rated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 21593.0 | 2021-05-10 | Reclame Aqui | 3961927 | kaique.barbosa@gympass.com | joabinho99@hotmail.com | 1 | 21593 | NaN | 2.0 | NaN | NaN | 13881.0 | NaN | NaN | 0.500000 | 0.0 | 0 |
| 1 | 2 | 30084.0 | 2021-05-06 | Reclame Aqui | 3952516 | luciana.melo@gympass.com | camila.almeida@unilever.com | 1 | 30084 | NaN | 2.0 | NaN | NaN | 9067.0 | NaN | NaN | 0.666667 | 0.0 | 0 |
| 2 | 3 | 47027.0 | 2021-02-19 | Reclame Aqui | 3670243 | anderson.santos@gympass.com | flashlav@gmail.com | 1 | 47027 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.000000 | 0.0 | 0 |
| 3 | 4 | 54194.0 | 2021-03-22 | Reclame Aqui | 3795980 | gabriel.almeida@gympass.com | nancy.jikihara@voith.com | 1 | 54194 | 1.0 | 1.0 | NaN | 1066.0 | 57865.0 | NaN | 169.0 | 0.500000 | 1.0 | 1 |
| 4 | 5 | 56234.0 | 2021-04-16 | Reclame Aqui | 3882995 | luciana.melo@gympass.com | erikabazilio19@gmail.com | 1 | 56234 | 1.0 | NaN | NaN | 1100.0 | NaN | NaN | 10.0 | 0.000000 | 1.0 | 1 |
| 5 | 7 | 57350.0 | 2021-04-01 | Reclame Aqui | 3831206 | luciana.melo@gympass.com | tatiane.jesus@taesa.com.br | 1 | 57350 | 2.0 | NaN | NaN | 718.0 | NaN | NaN | 53.0 | 0.000000 | 0.0 | 0 |
| 6 | 9 | 58058.0 | 2021-02-04 | Reclame Aqui | 3610902 | danielle.hernandes@gympass.com | andreassenco@gmail.com | 1 | 58058 | 1.0 | NaN | NaN | 440.0 | NaN | NaN | 37.0 | 0.000000 | 0.0 | 0 |
| 7 | 10 | 58246.0 | 2021-03-04 | Reclame Aqui | 3726711 | suellen.franco+core@gympass.com | wasgoncalves@gmail.com | 1 | 58246 | NaN | NaN | 1.0 | NaN | NaN | 18179.0 | NaN | 0.000000 | 0.0 | 0 |
| 8 | 11 | 67449.0 | 2021-02-10 | Reclame Aqui | 3634981 | suellen.franco+core@gympass.com | babixf@hotmail.com | 1 | 67449 | 1.0 | NaN | NaN | 392.0 | NaN | NaN | 197.0 | 0.000000 | 0.0 | 0 |
| 9 | 12 | 81043.0 | 2021-05-12 | Reclame Aqui | 3972597 | danielle.hernandes@gympass.com | daniel.saggese@gmail.com | 1 | 81043 | NaN | 3.0 | NaN | NaN | 6990.0 | NaN | NaN | 0.333333 | 1.0 | 1 |
Last rows
| df_index | Requester external ID | Ticket created - Date | Channel | Ticket ID | Assignee email | Requester email | Tickets | Requester_ID | Volume_CHAT | Volume_EMAIL | Volume_SOCIAL | Tempo_Medio_Chat | Tempo_Medio_Email | Tempo_Medio_Social | AWT_Chat | %NFCR | %Insatisfação(CSAT) | CSAT_Rated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 669 | 920 | 18640265.0 | 2021-04-27 | Reclame Aqui | 3915302 | luciana.melo@gympass.com | sneiva09@hotmail.com | 1 | 18640265 | NaN | 1.0 | NaN | NaN | 3829.0 | NaN | NaN | 0.50 | 0.00 | 0 |
| 670 | 922 | 18655961.0 | 2021-04-15 | Reclame Aqui | 3880457 | danielle.hernandes@gympass.com | ft.oportunidades@gmail.com | 1 | 18655961 | 1.0 | NaN | NaN | 3711.0 | NaN | NaN | 19.0 | 0.00 | 1.00 | 1 |
| 671 | 923 | 18685162.0 | 2021-05-19 | Reclame Aqui | 3996381 | barbara.priscila@gympass.com | thales.berdu@bayer.com | 1 | 18685162 | 1.0 | 2.0 | NaN | 1013.0 | 12767.0 | NaN | 1691.0 | 0.50 | 1.00 | 1 |
| 672 | 924 | 18685771.0 | 2021-05-18 | Reclame Aqui | 3993205 | kaique.barbosa@gympass.com | andre.martins@modal.com.br | 1 | 18685771 | 5.0 | 1.0 | NaN | 962.0 | 11879.0 | NaN | 332.0 | 0.50 | 0.25 | 4 |
| 673 | 926 | 18814467.0 | 2021-05-24 | Reclame Aqui | 4012508 | barbara.priscila@gympass.com | flaviaduarte@vooal.com | 1 | 18814467 | 1.0 | 3.0 | NaN | 1333.0 | 6891.0 | NaN | 14.0 | 0.25 | 0.00 | 0 |
| 674 | 927 | 18838144.0 | 2021-05-04 | Reclame Aqui | 3942142 | kaique.barbosa@gympass.com | hugovinicius93@hotmail.com | 1 | 18838144 | 1.0 | NaN | NaN | 702.0 | NaN | NaN | 1750.0 | 0.00 | 1.00 | 1 |
| 675 | 928 | 18845344.0 | 2021-05-11 | Reclame Aqui | 3969697 | luciana.melo@gympass.com | wendel.guedes@itau-unibanco.com.br | 1 | 18845344 | 5.0 | NaN | NaN | 1647.0 | NaN | NaN | 24.0 | 1.00 | 1.00 | 2 |
| 676 | 929 | 18868795.0 | 2021-05-06 | Reclame Aqui | 3952988 | barbara.priscila@gympass.com | rafael@vaozmedia.com.br | 1 | 18868795 | NaN | 1.0 | NaN | NaN | 3787.0 | NaN | NaN | 0.00 | 0.00 | 0 |
| 677 | 930 | 18934000.0 | 2021-05-14 | Reclame Aqui | 3982276 | barbara.priscila@gympass.com | contato.athleticpower@gmail.com | 1 | 18934000 | NaN | 7.0 | NaN | NaN | 10299.0 | NaN | NaN | 0.50 | 0.00 | 0 |
| 678 | 932 | 19066870.0 | 2021-01-07 | Reclame Aqui | 3489502 | suellen.franco+core@gympass.com | lucashaddadf@gmail.com | 1 | 19066870 | 1.0 | 1.0 | NaN | 1717.0 | 2931.0 | NaN | 38.0 | 0.00 | 0.00 | 0 |